SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514615 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514615 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946239,264418,777190,951947,725994,966274,458589,141204,484377,840869,412980,8201,742037,527861,728318,396595,247303,762131,797035,322722,56500,71137,548844,994812,782942,483528,388509,304622,629236,103594,259988,859716,347844,709419,952041,829810,811221,1035720,717235,453738,799194,834708,614427,881756,135527,1004435,923329,1045914,511513,292350,248387,208310,979894,727304,44367,6637,765118,1016342,57133,174089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003169s ]