SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002942s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542652 LIMIT 1 [ RunTime:0.002010s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542652 [ RunTime:0.002059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201104,469288,35643,652845,868801,442571,642772,999379,447079,742080,434098,129545,710514,808308,955549,883903,104624,832767,428965,364739,974839,782978,634341,257278,436508,703579,1033255,376101,193344,935531,767351,598566,1030332,723690,167713,136145,98274,5397,239885,198000,225957,743255,1021532,125977,553006,898963,779543,438979,633001,349824,216951,77085,387100,185050,501418,916111,747320,893343,232824,989658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542652 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542652 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]