SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687580 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687580 [ RunTime:0.001468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513488,154373,987367,986046,912762,828986,550405,674881,1027138,651409,569184,173098,140980,665977,64307,411117,214202,29854,1006772,956469,17877,258491,78041,600831,739191,950118,261455,291989,667310,366927,940548,189601,919151,357433,289186,864120,89864,177519,30731,213626,208279,909651,138929,859372,408250,165518,591896,324420,244352,141120,973328,769629,401621,416274,126934,355585,887436,375830,522889,480527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]