SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 745004 LIMIT 1 [ RunTime:0.000972s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 745004 [ RunTime:0.002499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702724,765353,641910,882451,511187,138266,347384,826730,183102,380218,342713,828294,533524,484186,126271,336943,138810,242564,871484,1037762,406936,100160,1022832,50351,648797,134265,445861,646724,272811,215320,231088,649565,271367,104983,824070,1015801,42033,776309,285080,441250,15212,418460,290944,615136,636620,319373,139544,961845,210865,108419,674489,165597,1034617,228694,760014,118893,148128,1000552,563465,749828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 745004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 745004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]