SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461731 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461731 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032106,529939,686262,618379,1045726,578343,539986,1039624,255878,897389,190562,1017400,120944,115375,79330,927714,156300,701116,670962,959952,419753,927282,556979,361510,704427,765064,948678,409221,692283,663295,394386,93430,319235,154951,695777,965169,35393,397668,432401,122196,387639,476611,118068,505136,500241,132677,565576,126520,511255,18017,284017,189219,581017,21549,628321,358780,505203,982593,248806,954137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]