SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 133091 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 133091 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440018,544714,100663,393607,353715,959524,800653,401672,254578,982074,739629,955194,193219,679594,648578,24304,957347,505283,34635,613734,303067,605624,398169,902393,1111,438590,390614,202246,144927,932076,248776,448592,907364,903904,572235,605383,341460,924173,876647,696025,509274,920827,697142,232285,355851,171967,286974,474264,583446,154373,196475,415502,714860,488202,903935,571425,772952,471697,731867,243204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 133091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 133091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000377s ]