SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111014 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111014 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835856,839583,652113,343499,527246,598768,351162,536921,571823,185085,192885,465907,644320,319347,18328,403476,724027,623335,1039571,280511,81131,299250,87083,808965,87035,739533,769401,52324,911655,659711,712206,176341,839322,713902,652253,175056,183903,263746,802046,931036,990714,258694,212456,879719,399553,948277,509100,991775,797230,231312,36848,765909,912275,432931,650684,455974,962732,388689,914244,145475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]