SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809912 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809912 [ RunTime:0.002561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897103,855045,104044,472270,566101,798146,923368,745057,647314,985117,33364,570207,739808,708633,910050,857914,113104,383400,195074,548234,785762,423297,619921,296019,477980,1014071,639325,634194,643400,902888,140620,471258,475192,46898,708458,870403,1045250,58883,1041146,885442,980142,806169,346632,300737,580197,334267,518404,77315,485948,134877,723330,263172,789495,907556,763130,61034,315975,988123,425426,869671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]