SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415081 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415081 [ RunTime:0.002115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69410,463231,209944,834336,715300,1047795,842574,333085,122759,857698,636124,328318,242925,558971,429566,33459,987590,895174,740030,966803,356156,553863,220568,908678,938436,26678,229532,387161,434713,44804,12894,646697,589768,222564,25390,775471,298269,372669,408599,874253,546745,44939,760108,123614,396527,1030624,122503,82591,798231,696267,551873,607255,144179,956514,516290,100062,25716,946257,535925,541465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]