SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020654 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020654 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799978,472810,546050,751956,300767,463620,430968,838769,602224,799439,862785,646813,743870,50113,585375,259226,737203,828095,127645,422963,552900,872617,282546,412974,588882,683932,821049,831255,503276,473129,353279,822985,277762,29518,705921,704173,576835,993586,259711,415595,403877,716256,547478,936191,152863,816658,375810,255432,527475,84850,792824,501366,1035446,33005,886250,702361,452949,841314,646781,346405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]