SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 22474 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 22474 [ RunTime:0.002662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012749,905487,728990,858702,173511,863921,517798,116873,532800,678960,255097,964672,826568,322521,521587,689075,875902,350690,541044,135507,423628,980248,157411,212818,393354,56713,637289,218216,1033175,314088,534949,122498,395640,18834,652496,136137,893379,655239,542532,155201,807836,70109,224905,760402,244542,266120,6011,380549,676048,946625,761837,507360,80292,802147,578644,630889,776837,157584,641356,401423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 22474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 22474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]