SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414292 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414292 [ RunTime:0.001416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004396,952361,163702,111273,346987,238638,457211,725946,259709,99187,913724,882130,907638,972448,837873,422366,868830,125984,955389,611743,35077,143633,328170,159993,352754,440649,66745,122644,547613,916041,501749,621110,240756,76119,519329,895189,701852,188640,278505,38673,81510,223586,28981,751070,821031,471775,476112,288082,436513,658089,1007779,99302,953801,326048,123405,633708,448231,949187,396753,553937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]