SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311054 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311054 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108263,697778,652952,130654,622117,954199,899932,723768,979106,525610,671718,208285,426167,443865,420562,342043,175781,582509,872830,41415,888148,934857,1004565,1036443,454396,415454,1021035,1025175,910384,623108,518616,551734,1043968,637540,699628,964464,265925,485154,376574,510262,374142,383545,966829,248839,545962,660082,881595,817653,614146,804268,583675,983849,84300,422894,793843,539145,96800,602359,538633,543265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]