SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508103 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508103 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610968,590713,723420,488291,792869,835567,164902,636193,401925,467478,264880,117266,207582,1000292,733386,505835,779912,532610,1033195,569620,259119,708196,839456,642204,1025782,650676,212239,263460,719075,632085,239930,513117,996286,31996,569816,409267,799076,268316,528862,463670,44249,723358,613015,735968,681906,826245,851324,534343,426236,57281,152326,510555,718815,1009411,45922,47546,852398,263888,1002054,438088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]