SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010836 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010836 [ RunTime:0.006575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023981,235807,419701,381226,900393,775877,536625,435748,956069,785519,681561,513014,936077,866582,942525,763119,808706,73624,804735,626636,462004,599679,424237,505098,486571,97499,371004,610907,828117,805208,812686,888402,109120,1043111,50170,478564,639275,328732,93054,464755,887222,492433,79265,723151,955374,137896,394422,982770,165277,322412,1012967,945050,679622,48001,468826,460093,617964,524156,139844,393228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]