SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199536 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199536 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110280,441884,113669,393370,1044706,473323,784755,375400,672906,115740,176943,209050,45495,255198,403541,95064,531143,238640,934635,246878,207885,438095,751524,328440,1031393,594008,441891,379161,166036,944167,362777,182470,66638,284146,232849,936136,190247,742466,333721,1022737,711859,877500,976375,301598,297080,351629,324620,195196,543251,945671,110393,746934,855559,844826,405844,731637,227375,359074,682310,528165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199536 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199536 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001490s ]