SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505131 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505131 [ RunTime:0.002169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280741,528008,784219,642052,834812,197718,58886,534943,178528,256134,796159,26430,187318,356118,1043346,188518,177126,505937,396659,608736,378686,145674,661243,704544,372985,424372,962964,746430,521492,591505,188483,925120,867714,776489,377760,559992,352342,392815,1043725,901727,408050,109901,269520,42945,921822,518810,261014,740579,55165,151084,949763,923330,773337,207151,730749,731469,158281,306225,909219,838745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]