SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019964 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019964 [ RunTime:0.005774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470901,507469,220848,510924,533629,238528,343653,747268,679354,357277,228295,223428,439132,674684,631257,654913,771226,780978,691271,807293,307324,538742,237924,340746,1021132,1038359,301809,603816,240498,598134,703906,574657,403425,664998,980874,121596,203908,878608,609303,400436,505810,226027,307858,387844,60044,590225,923185,960850,101313,294142,20469,956844,975059,781014,823230,982482,575118,754022,225655,788203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]