SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004623s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26568 LIMIT 1 [ RunTime:0.000516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26568 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868881,299116,332951,824568,987496,397218,153812,963564,780028,136386,781828,203416,945364,92796,69570,834932,357989,875464,77303,865084,351558,927311,614090,584732,1034920,47437,832836,898507,766449,800246,438516,978045,919702,186163,439043,520503,1039204,93899,307406,478682,699898,93451,742679,186207,802194,754500,779689,924471,747006,776913,257655,769115,230853,160267,727738,415053,47461,634014,445939,68943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]