SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54600 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54600 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562230,371424,483062,950373,316,625887,489948,449656,618898,106457,919228,693222,132855,385256,678558,855142,99516,426730,339385,56231,722352,742519,95154,1015592,506059,819206,618310,957899,938368,303272,422122,6994,406216,682866,386214,974268,660685,497686,480369,29337,172260,819936,1034743,1020349,240537,309326,42029,1039924,340194,641041,282212,56043,636147,204054,795751,576707,923590,121175,634165,63248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]