SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511592 LIMIT 1 [ RunTime:0.002844s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511592 [ RunTime:0.013954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134484,1010566,120427,285183,789901,218551,1029474,151526,355015,117724,86628,1014628,914131,562285,652175,30123,723018,1018746,83509,818297,398903,773167,255674,841042,534244,360318,613613,1016249,340029,392068,435471,507828,304590,942068,556721,222480,957823,839950,643941,850415,109271,213808,646357,251069,281390,996978,529241,293368,532577,444443,532320,772707,780880,381250,1013253,345512,268197,545600,510186,24698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511592 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511592 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]