SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415841 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415841 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689379,216971,567442,729104,474499,431446,163758,60430,616079,336960,920838,348095,1019087,973230,175857,575872,372706,693771,536521,920471,1002942,262566,671990,551089,804754,283560,277320,301538,385575,291429,267355,796803,797741,310854,129331,401849,369322,44959,95572,638122,877420,778029,1019278,683140,138008,228769,273433,210486,487922,529754,360495,732878,544925,131983,363069,512908,1036427,967391,118947,683491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]