SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541799 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541799 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201420,262727,905210,949117,76850,526986,312700,45179,739157,353416,339208,703412,231080,571623,693793,81094,394018,422199,983744,118023,870846,949317,628731,748069,597491,669598,538394,290532,223645,960779,97849,776229,854197,921365,32898,766731,991567,6242,383191,486961,233375,324768,609864,150973,79367,748554,477765,968056,847915,495095,829494,64523,810030,657390,54286,334694,733512,183301,520554,143493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]