SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319113 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319113 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730837,952836,868063,263277,184915,610856,186235,742437,393548,517686,1040265,5121,755962,20109,416357,266693,68586,1048712,144364,142962,553487,528646,358239,109100,343271,277359,563612,106425,290664,993842,442013,31291,239525,731190,829426,124683,906830,660736,975504,243466,846681,683564,815029,403026,892551,954024,275604,222554,1032903,419669,518188,287960,948797,669932,182058,441500,420686,1021732,669390,855275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]