SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508871 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508871 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774558,767537,125918,114575,276403,604372,607686,451365,789929,646321,810212,125230,48096,211813,652781,917976,464190,729674,476870,5652,782554,317307,363733,588050,227136,496644,891713,621586,942073,291556,208925,200871,546289,246360,579858,921465,430284,411539,37732,479540,863820,343820,568408,1020285,709499,270836,922435,317433,265435,730395,474671,315954,671702,164740,575576,980572,302591,483584,956425,171294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]