SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 15401 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 15401 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851580,604769,175158,23585,141846,154481,529670,538523,1014564,143613,796096,467625,364893,263298,191958,760860,408263,546098,335397,170274,888583,840528,515783,342154,779205,383420,795553,319934,278704,802103,90656,77254,328451,278229,56922,788399,223291,902995,292061,995930,1040433,385421,1024203,738431,853848,599701,618385,380501,487740,686805,791447,364915,320416,615109,266140,166264,330879,352257,71178,99110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 15401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 15401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]