SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 86009 LIMIT 1 [ RunTime:0.003110s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 86009 [ RunTime:0.003050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436773,22724,925033,233788,34393,597177,388591,866406,434365,148485,73567,200783,458415,173042,425048,135947,103043,136826,910691,523771,262041,164272,92903,780712,252418,455892,242470,227922,149786,749909,858340,772406,959480,1025812,82905,257647,85891,457586,1044165,696148,17795,453365,964971,521609,705667,76856,303586,128751,731040,894392,534841,918773,572124,813764,919616,591599,632550,415057,1002712,533053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 86009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 86009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]