SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003049s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445620 LIMIT 1 [ RunTime:0.000909s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445620 [ RunTime:0.002042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380101,577151,214581,996282,636459,490075,50181,670625,918495,216694,576532,710700,569742,429011,960163,936385,312787,281832,431004,854605,197539,382765,762335,732327,260099,471068,317679,551363,686194,192297,353967,365761,1040636,548144,685505,555014,351106,2870,589401,925843,500427,566345,735451,754046,825727,1032385,146663,780297,725459,607175,328471,102028,542323,163352,661779,40627,765402,181396,793785,315472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001868s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000839s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000848s ]