SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001840s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314431 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314431 [ RunTime:0.002199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489193,953532,1012719,148459,832365,1015659,159864,808375,301961,566500,845099,262059,880709,948172,171937,262430,891936,330177,1003106,416020,325901,328440,23053,921401,446195,882999,830625,573528,774684,818007,804935,321542,1027232,875854,188002,884600,222647,279028,848136,71341,480842,424143,263064,158918,7447,31318,384217,67918,693494,841481,148419,349776,967191,153385,202517,725215,81725,685244,182129,295188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002450s ]