SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020658 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020658 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815260,255821,600488,124262,957234,805728,739997,367209,367704,1038725,504028,251744,709770,527379,747792,385329,872037,97907,280780,676823,377603,266676,95314,934165,44126,120402,154702,310731,171353,435159,976481,799860,193501,702163,266981,315453,409265,258098,905381,194123,474013,675205,225930,679958,483956,171535,1047663,458909,44665,418006,280814,290460,365193,514709,911279,367551,284084,221171,876621,819263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]