SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396709 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396709 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862570,40752,990878,291327,598447,42502,20171,406499,744317,366563,181331,372745,224589,664250,464725,449661,331324,494508,107683,100532,372215,705557,734645,108815,388437,49194,44896,318447,387889,715021,934544,681011,940733,485725,245735,120031,945098,506833,914585,813190,452812,236831,205143,113564,346284,472013,935082,788927,912593,4593,887220,492060,468819,665573,363408,726134,58178,398230,894031,1037344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396709 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396709 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]