SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004693s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540680 LIMIT 1 [ RunTime:0.000725s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540680 [ RunTime:0.006154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158144,266806,897623,110678,254408,430703,33704,778194,498460,710962,498248,532322,498848,336897,849639,279285,22651,1044623,40637,456508,777481,178173,729612,501516,6962,292801,911901,387044,483492,899760,799708,930204,975406,955390,942483,182640,393597,1005726,56249,607879,524057,916790,481289,888910,507885,473432,746088,282265,1003583,815378,742832,554107,257493,933664,829933,767862,952512,213141,228450,269000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000921s ]