SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203800 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203800 [ RunTime:0.002739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800142,923293,323031,579935,63089,487673,338556,68475,241369,329491,419165,620041,1038406,397415,702001,300755,530586,939157,727231,466991,830014,596607,529609,58580,678443,311576,418693,579304,310397,229857,791116,998788,389775,588617,1034800,596997,534420,824102,231375,191919,295315,417833,311264,515151,241282,852201,647251,72505,700093,693647,545402,351855,619736,563827,176796,725158,255134,761272,736678,569220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002321s ]