SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022875 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022875 [ RunTime:0.002397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662943,583374,258546,427258,22320,488700,413887,998653,708651,81403,436070,596431,605148,278202,370535,657141,127242,7673,640396,36398,230612,757026,262986,572740,11165,458728,566762,722396,431702,296960,706283,442466,973095,665210,457136,108494,892941,180995,389259,17997,730425,877544,395478,780662,33231,913109,752313,116618,89880,268575,471704,1002980,466739,485015,933539,658765,885667,810111,873652,672827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001354s ]