SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038313 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038313 [ RunTime:0.002445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105113,652673,326162,997555,842112,800421,946113,941613,223791,182689,133033,857096,427894,168785,636271,275103,433066,298411,183093,22239,604372,799041,670445,164733,503954,205731,789693,755702,249664,680122,731861,464997,564562,867832,125013,1042594,47763,342337,284337,386885,957524,981512,14647,597787,488926,264883,278680,287458,645248,826327,808538,659942,321812,722313,1004693,1030970,862110,11250,102078,590197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]