SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037275 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037275 [ RunTime:0.002042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992653,1026323,885521,148454,253042,457354,855153,171944,510441,312895,855680,124239,858484,234633,125813,668140,764333,837366,995653,208625,321394,369549,663831,188403,701609,572303,675256,272301,392591,996975,538845,476241,750286,111587,778752,893430,867633,980203,842985,521915,342843,795627,690369,515670,220672,898735,109895,415057,752702,334736,743734,843074,1013750,636577,353386,353022,113829,580135,399307,776583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037275 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037275 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]