SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445700 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445700 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242796,990962,1031062,560461,708641,80050,560046,172970,93470,869331,913013,801283,617876,343791,778469,558683,593064,341511,811853,1331,1014983,368715,314927,536815,717940,1038609,756398,461718,542965,943892,715290,249538,24848,633475,354699,816165,640243,1027558,789577,171303,259168,194263,1014201,585039,120710,793062,255144,698636,853818,961915,652038,83501,328148,782073,600350,210380,221320,749889,24144,48733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]