SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580474 LIMIT 1 [ RunTime:0.000667s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580474 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936358,766546,957077,919561,99807,102969,793650,341890,3784,672911,519703,384789,662661,1040262,847161,530078,125993,64087,948483,589031,245821,342331,1009516,855688,294800,134504,1006189,752980,886907,211388,448561,111467,186904,146960,243138,195285,957144,82658,1035415,1022417,559411,181437,581337,1036904,785294,951781,370559,263871,523658,829477,942920,837645,91598,437746,540222,88438,444379,486113,467956,597810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]