SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 357254 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 357254 [ RunTime:0.003772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40327,66807,202962,961175,286708,161754,114241,613124,345922,1010301,766161,593680,945183,150280,789155,621286,498611,284276,300756,549704,46893,175690,351043,717198,347569,523176,846421,48196,100244,520154,597048,155833,896738,314151,851800,73049,448318,574436,191997,380842,518239,372811,698354,399111,453107,457238,893156,787457,271386,616065,966989,373840,106351,431236,585438,323154,772466,342740,962308,223241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 357254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 357254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001304s ]