SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048442 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048442 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71288,225418,278427,140111,290242,1015853,195829,749871,934645,684453,141026,335288,694560,928307,171397,681046,240710,193785,822288,505164,911120,993893,725960,585247,578501,41196,47457,749159,238137,39507,204786,479922,372834,303382,924258,341759,198863,739533,613723,246519,1009937,298985,955160,288339,58926,380775,810006,857415,746042,244624,189449,990244,82660,58967,937947,637414,686566,370111,175582,293644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]