SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451282 LIMIT 1 [ RunTime:0.000612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451282 [ RunTime:0.002717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455730,845089,728109,866445,899989,404921,568240,1018440,448113,594091,848160,425036,574610,185753,519409,745456,73933,823558,439587,982680,255212,551366,185899,135455,740963,540366,22922,780483,488618,143100,741179,88238,1045347,906490,87391,315720,725961,579433,180281,560738,787149,480345,418013,103882,767370,818458,143033,899429,796628,775329,547179,104536,590934,739068,194687,1023880,312375,135391,553470,440809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451282 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451282 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001774s ]