SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413927 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413927 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334678,236142,1020829,989567,981294,585239,797180,198743,81519,257389,949241,232566,93206,297436,167728,640634,843868,334232,899437,695657,58845,472048,576194,438573,878144,413230,291390,514889,571387,267989,315792,294768,303831,877194,927057,936360,53720,610719,1037782,262664,982845,790925,866700,355251,14086,704954,855632,466661,745999,130844,474066,138112,416247,753367,224967,362445,57534,830807,384277,407826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]