SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54368 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54368 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454630,402826,853685,608342,519553,426550,612082,427063,764281,557510,391267,1038269,770452,998046,347512,755704,847930,335307,589946,401835,983268,557620,16987,137359,495625,211282,427978,6657,23889,879665,96313,742348,686157,799695,598857,974687,796033,686830,425333,257064,835041,799942,833224,848361,912492,144094,2907,610967,293592,497889,147973,1030949,517125,359727,105749,342721,757401,873309,20590,200389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]