SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001921s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39860 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39860 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385784,23876,510099,188122,330145,515111,985134,808858,264209,937127,375418,401912,41166,857404,573114,866358,244905,473885,909529,15015,639100,926532,542763,813878,346865,666636,255149,668468,291095,373115,910734,739594,703916,849427,947726,265404,393877,134279,745645,383945,713067,882251,430709,319934,652719,93268,897113,413225,259769,197297,1041143,239974,182550,507736,267692,42711,819793,385161,417822,594706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000391s ]