SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018784 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018784 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338231,897110,148912,529676,666777,158195,752033,1018587,136292,873565,45445,763805,990975,887381,1045903,956613,1043117,235379,145078,240937,760016,484548,102147,703449,771648,943002,768920,446008,226383,115544,797961,683858,899134,318255,266284,768710,941386,593191,878872,523334,934651,553859,970670,588040,570762,112400,815323,496414,906424,167947,477816,706732,430859,634757,941730,502250,492397,869345,404618,670817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018784 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018784 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]