SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002844s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801418 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801418 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37554,329599,315906,689156,796611,77011,416050,499075,735958,580345,979835,199727,487388,302722,698413,808744,477006,452420,528914,418268,673714,791091,199665,239465,831312,861403,587293,540912,38092,108674,71918,100443,704413,756416,717768,550386,403164,206902,15199,864431,310088,921698,690141,948418,645766,161698,558335,408310,42652,445439,995382,931513,1005857,234457,1031219,920672,183256,142961,395614,277886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]