SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536597 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536597 [ RunTime:0.006094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860535,417208,1034998,942171,851253,247690,493684,265573,154679,915461,110327,109870,805366,967673,981163,726002,867215,974636,414269,215886,1034456,859739,607992,138674,134577,600695,43824,142979,796583,264179,357188,395906,45848,799147,750470,731185,276775,996172,125065,401436,676963,660698,25463,575743,39892,717731,903928,173800,189673,937244,148226,647174,780926,221550,818442,278427,309440,902057,893993,383928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]