SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 744091 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 744091 [ RunTime:0.002642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546953,518792,959114,450166,876431,559461,61402,578291,118494,1003364,836132,4948,99201,375164,1048360,894308,780115,1042175,834031,148012,558775,764489,729832,519347,870675,1028655,155253,245676,950479,174589,8825,577002,960227,335356,303909,330924,536836,1033236,908998,840177,448251,543980,531461,593660,548601,780942,182322,45911,676603,725250,269127,294386,907652,157224,1007388,41536,168478,159818,922920,686753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 744091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 744091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]