SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50967 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50967 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (769,458281,590776,300432,399534,29166,177815,162223,663003,661726,887892,510858,289560,479456,978218,287294,264293,828476,828157,400237,318768,406676,883137,478244,895581,702715,844616,360530,582535,593889,32033,391855,708778,552158,3651,1046419,1003290,374360,234250,705938,907164,460665,234887,244426,709287,847991,988091,332938,657796,487888,997058,728460,1012353,1017546,152420,647133,10641,356635,273042,221184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]