SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413441 LIMIT 1 [ RunTime:0.001092s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413441 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234696,746013,183471,556540,1010131,968360,621478,379819,234924,631816,1036124,302057,1032776,305129,449437,280262,735850,687046,919618,590637,332769,164201,688537,304785,613141,703076,268485,403610,40964,952365,394778,304705,657148,556423,236749,238454,281426,43308,919621,1047512,629941,77620,854653,871789,308646,243835,437456,481116,959307,44108,824745,720694,38595,757771,940475,122557,1014163,934619,15601,241907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000994s ]