SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004540s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016981 LIMIT 1 [ RunTime:0.004008s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016981 [ RunTime:0.006765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291900,182223,720541,992109,96608,853810,913073,251409,587557,364539,110415,67628,706372,158986,521279,267107,862838,440238,45400,551666,939326,8817,804325,409673,710193,398516,708618,554685,848741,382367,504468,296959,706457,121647,221628,483086,977832,1009655,444196,559363,549691,1002086,878061,205793,233165,171737,665585,549649,66975,147553,682336,222325,455079,824268,1033975,269468,436783,653719,137730,177547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006298s ]