SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491008 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491008 [ RunTime:0.002158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847405,703127,206757,929398,67300,871725,279745,50097,406886,530732,626478,341703,222460,617387,693008,756636,707334,416426,717122,933518,834421,1023414,119495,212558,630082,713908,292787,733923,557507,639288,416647,354585,520385,64830,978119,539192,515379,681726,565865,411609,146053,288508,245928,445449,376068,990322,547513,851427,208801,330578,390327,673590,351218,327929,893408,347548,56484,1048481,110384,372385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]