SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 756106 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 756106 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534292,643529,469047,340990,371965,532721,610593,831865,149618,870802,1004233,244906,631246,339159,230736,160418,867653,685875,480093,68911,671058,85259,420703,166809,248573,775503,786270,873291,225666,624611,799662,481457,698614,381036,854000,771179,705668,1043239,1015039,781128,16024,122695,236935,734831,182744,373984,336931,475897,232246,351387,262579,776386,168189,895252,942992,37010,49983,207603,41574,366695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 756106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 756106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]