SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41741 LIMIT 1 [ RunTime:0.003308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41741 [ RunTime:0.002403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350221,127627,589634,961075,986821,837938,901036,548738,706718,944462,436192,744879,680528,702614,310042,358005,404805,914894,103567,823109,828118,492096,50457,672141,109003,217077,941765,377355,638712,1041235,22285,849831,629764,14521,994166,26280,338196,272444,1042726,415318,837960,746800,784567,103388,721142,755975,492505,175689,729038,767002,144803,602206,1043478,212583,229654,261762,161742,745752,704710,1017869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003832s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]