SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311638 LIMIT 1 [ RunTime:0.001214s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311638 [ RunTime:0.002665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352411,239247,812813,394459,416344,154450,505779,689667,853904,806840,784963,550728,745176,1012433,1047555,476617,273460,541214,350432,402253,953509,208064,361508,909907,149406,398978,757573,186006,861575,713158,267543,896819,202105,455137,251893,348644,25265,182153,188374,963683,790434,371735,982452,600608,553920,9855,87813,896516,625233,812271,984554,353479,156449,845181,1005271,733675,963354,606816,969597,142875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001908s ]