SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545383 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545383 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160923,968407,201790,966465,566542,645578,184840,696107,811140,546764,429030,384079,1031151,232251,386245,6890,250221,497141,338389,626540,798541,286415,118919,695964,450996,349471,388690,567081,672828,934502,470081,970286,453121,902715,381652,930441,894908,191454,682057,299979,351218,391352,420168,569428,19836,34643,670743,804546,889836,293536,541671,137094,904058,478927,556539,792336,841633,891887,983235,658652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]