SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450320 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450320 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201709,180300,576524,316903,908215,192160,567119,60930,363229,118215,84362,916164,595546,882465,241478,916480,976339,37828,805086,664505,559195,754368,1028115,452489,182908,423361,904611,703376,881320,707483,548051,578388,497339,982611,313376,223397,247967,219802,677262,562947,832876,474106,857853,712167,135653,316000,258135,234539,93073,215934,782153,705117,276019,1046146,16872,457317,785966,698554,681490,142342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]