SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517352 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517352 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017998,985661,792727,910091,895388,31887,178261,509705,143806,279288,283045,480215,596713,373802,230308,294176,50970,268951,414179,387958,904934,488998,127624,998,799351,896903,563497,466486,806260,426529,316385,836413,16166,255729,795514,710477,508613,576030,51106,720482,380866,547964,563753,902123,688448,377187,842721,752816,459525,121711,934188,370645,480072,171557,684051,369625,115923,699712,569193,165400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517352 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517352 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]