SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450526 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450526 [ RunTime:0.002487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866329,1037195,1007447,490990,154612,351974,972848,44861,501250,720530,130750,1020976,257645,15463,399343,1010220,653828,5386,925476,640017,86608,83551,479204,299145,32655,358089,24521,13348,772629,94966,534670,161333,342039,723352,944135,121731,369079,240286,331059,569924,310260,835088,140258,298905,1021550,664195,180407,691925,294532,757024,850723,420957,129980,918099,980843,987479,681040,168478,740431,974820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001293s ]