SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324060 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324060 [ RunTime:0.002615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470,662675,729912,209707,658714,811396,275304,390187,56152,475610,835933,287818,907894,117447,98679,506537,683325,38037,933733,176063,363370,975510,98740,313539,11049,126410,308328,120259,538716,489891,762706,832864,818769,12211,761441,47600,342330,1000495,302793,1006065,1043805,81608,635082,114823,212545,861543,374573,541428,428075,918960,985293,772754,856004,1010977,63950,72558,15913,678992,393135,675866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]