SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046906 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046906 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206904,862506,239677,748322,109174,888179,261722,740397,780919,299979,872297,1017254,947727,792532,93495,74683,367675,428297,691756,372184,589947,200349,98356,856499,908412,877906,626572,320734,562487,791571,523328,595043,431300,334777,436100,638023,840492,960003,168269,522512,1045957,427582,385702,769295,558576,485326,682565,627606,389680,502800,512822,684907,129022,261316,322995,930779,490200,601243,814240,128307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001312s ]