SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584410 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584410 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547058,426478,136209,573532,780304,2551,635702,359625,333754,403139,269548,551749,939471,491913,245368,999070,843060,394018,615675,770855,422071,666988,998721,244262,132117,489517,547929,925924,321505,900730,744097,53380,557508,813842,266150,585751,137711,185577,437274,35658,559713,754131,41370,864123,120188,643075,559581,120264,879515,407381,400278,429456,667801,568167,27818,566054,367475,871677,593182,350436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]