SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102582 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102582 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55887,173870,664220,407839,143133,81137,298726,277194,706421,716351,608503,364826,401494,735631,232144,128653,1033734,408118,51016,440423,441225,97109,180070,804785,67375,412775,307593,31187,900939,627440,976736,688849,776895,964015,434636,617257,61030,296548,854995,512246,187997,996177,45828,825484,774969,479722,896082,757110,194391,903531,624889,859088,681228,113209,552626,771346,994380,1025346,130723,372479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]