SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023554 LIMIT 1 [ RunTime:0.000899s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023554 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582361,426260,193602,95139,152491,247171,540150,1016542,918218,1045730,41807,11794,1035369,505416,674738,717466,614936,966830,143259,405055,344958,70887,509810,71058,62211,892095,649996,48428,124138,828743,959850,647165,639299,231032,527646,826586,266402,826147,72780,93787,1055,979620,328060,509530,98956,360316,107936,827789,1016535,207595,401992,455418,802822,670283,271622,993349,397905,226973,311115,609315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006358s ]