SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454844 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454844 [ RunTime:0.002202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15653,123866,937325,780789,73045,802104,331427,441130,300148,958305,565514,247770,919703,866290,998905,476208,319800,20672,551950,940764,872124,80544,397609,27196,304285,285757,1031569,205788,1037554,983752,66321,104985,396441,372920,664365,574090,431706,360116,888203,670439,551300,964569,384679,663766,54227,579848,876827,648844,1036815,550626,245150,998493,606243,680781,285105,493596,621141,454453,594345,811562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]