SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005665s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492847 LIMIT 1 [ RunTime:0.000630s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492847 [ RunTime:0.005286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581452,406747,184635,922966,547298,445739,101300,803094,545579,1037024,572689,333946,853492,839050,161852,1014739,800245,589025,1039752,336594,223885,89703,501993,116311,258306,1019358,585889,981209,188579,427297,854397,796840,544634,312425,751383,792179,352378,565805,116096,351177,428889,364097,125066,618627,210135,188589,780679,334470,728454,36719,914323,662935,547316,518740,1012900,237964,556361,823704,354079,517679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]