SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 362698 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 362698 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181350,866379,921056,206931,43886,100076,888324,315478,68006,191368,528416,692654,51592,138962,559610,46142,102296,591778,478924,556769,857561,427515,126546,881780,233675,576358,680314,1002430,1042772,198174,800369,896819,363745,242286,279545,75271,588960,419084,673667,167941,235582,1019004,659014,920177,139208,960395,844859,360342,323015,583967,291084,764402,259708,713388,1037998,613706,461022,72353,495082,723683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 362698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 362698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]