SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464833 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464833 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139099,1036315,684631,381492,307971,863136,890529,1009880,80633,182387,919851,373141,748836,33858,870939,50924,521440,85335,891428,848515,601259,871819,739472,336818,222408,596463,226724,490315,184658,145436,650557,926370,57244,447315,82475,686031,725967,334499,1025114,896848,372374,196905,645011,643491,1037064,651666,289271,168352,606025,338725,261433,158783,587786,1028980,775192,498087,399828,922070,690217,202103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001031s ]