SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037499 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037499 [ RunTime:0.002028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471219,652832,481711,195541,828307,797092,967409,464191,609390,948579,241662,874249,108006,770471,717474,515132,1031188,328147,493930,149009,511280,343963,1038791,405271,26068,714893,181488,717875,520681,161066,577207,786655,480163,729334,861558,72533,202040,504746,242697,144346,296846,746127,103267,605855,243274,970559,85941,566642,79120,782676,743396,51629,769288,115224,135642,955032,839904,328840,202607,491091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]